UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '30iSy18+kfAQThOYVTY/msHL/c7MAoS0mgyB98uo7OA='
WHERE
key_id = 'a7cc1cac36416d7425874e3fdc228fc2da96f8b1a3ca5bbb60b7cc805881220f'
AND (
token = '30iSy18+kfAQThOYVTY/msHL/c7MAoS0mgyB98uo7OA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)