UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bCroJS9b+ref6dJcn+6cmySnlgeYtDqVjtAFBofmdCU='
WHERE
key_id = '6c49a62c2061cf60d53de54beb364c33105cf7b09e48dc3a1f24afedce27b9e7'
AND (
token = 'bCroJS9b+ref6dJcn+6cmySnlgeYtDqVjtAFBofmdCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)