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