UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nNKiGp9Wr0e/qRqK8G+QKgNMqRbi1J68iBdvsQZwlUw='
WHERE
key_id = 'ade4e7836a62a53c874696e439c5853f16eba6243849f232e8aff82d1b46496d'
AND (
token = 'nNKiGp9Wr0e/qRqK8G+QKgNMqRbi1J68iBdvsQZwlUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)