UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nA4fqNNwDFCAB4HkVL7UkFy5fc3yrR/tO4hvSs0gsqk='
WHERE
key_id = 'f767450ac4df8ebb496abe85a039a9762ef7449274332283cce44c9622b206e7'
AND (
token = 'nA4fqNNwDFCAB4HkVL7UkFy5fc3yrR/tO4hvSs0gsqk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)