UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yTUQEFIrC5E7hU889MOoFKzM6roTkpUGxjvUFAV7nnc='
WHERE
key_id = 'c6058f49a38a2d62ac9ba84009c6d8e245df5ad84a1d6d4a7e280e3ea3fbbc9a'
AND (
token = 'yTUQEFIrC5E7hU889MOoFKzM6roTkpUGxjvUFAV7nnc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)