UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qZG5BT0qt2H5xkGda+57B2P1EGy3Wo37sslCiIc00/4='
WHERE
key_id = 'aa5a74923c107833e06711ae51f468afe68ad3374584d980c3df643dc51cf7b6'
AND (
token = 'qZG5BT0qt2H5xkGda+57B2P1EGy3Wo37sslCiIc00/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)