UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X7hleuDCfO5cW9+w9DaAo3QBX0e4iEFVpp++qRYpR04='
WHERE
key_id = 'b9d8a2303f4e0f09f9fa36b29619fe8a99ae27f321452e08703fff08e910b7bd'
AND (
token = 'X7hleuDCfO5cW9+w9DaAo3QBX0e4iEFVpp++qRYpR04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)