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