UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zkc0X6tur4iEdFSvIXZ7FaUMBBBMt0qC7C0JdmjjIhw='
WHERE
key_id = '1dd8ef7d78509f917787d57893702f9af0f6e268fa5acc5a5e24fc4b78ac771f'
AND (
token = 'zkc0X6tur4iEdFSvIXZ7FaUMBBBMt0qC7C0JdmjjIhw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)