UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3bIW0c8nMyeU/Uwe2+daqD+Fx4Vhgc+tlSuv5H8uuAs='
WHERE
key_id = '9074d951e3b50c1e5ff15448874fab26097be571a84028e400738462bba71339'
AND (
token = '3bIW0c8nMyeU/Uwe2+daqD+Fx4Vhgc+tlSuv5H8uuAs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)