UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zQZdlJIp6ts/mFBDYFbHfE/uvlf56LKi8uY+tRGqDqc='
WHERE
key_id = 'd8187cb9e708ff96156d1832fc31b3dcb47fbdca27a5fa45233db93116e3dba1'
AND (
token = 'zQZdlJIp6ts/mFBDYFbHfE/uvlf56LKi8uY+tRGqDqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)