UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1G8XNRtTlbx4P9TJ6ce5LX7Y/WcddXaTskDEL9Dox0o='
WHERE
key_id = '1a8417b97ebe2b66bf92d7669f45312c8cc387d319012ee6b7eb9fa3c1c821f1'
AND (
token = '1G8XNRtTlbx4P9TJ6ce5LX7Y/WcddXaTskDEL9Dox0o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)