UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9CYYK8nQ3KVxDG6J8i5DARfvaO7eEKPQYA1pGXA7rLM='
WHERE
key_id = 'b6b8ef2fb877cacee09a90498f1a3760f31bd1a5484fba4e7b33ca096ce22879'
AND (
token = '9CYYK8nQ3KVxDG6J8i5DARfvaO7eEKPQYA1pGXA7rLM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)