UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w+Z3ci77PRmV3QXDOO5+9/0Sse6nDqA2CgYHrPUW3t4='
WHERE
key_id = 'fcd6b298c41c4541bc70d1890b09acbeda4c01b4f79941ffbf98b9e174fc629c'
AND (
token = 'w+Z3ci77PRmV3QXDOO5+9/0Sse6nDqA2CgYHrPUW3t4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)