UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SM0St6I783FTFZLWrkDdplOgT8fN0+ECi+Y4Cmf01t4='
WHERE
key_id = '19127ad4ad0e7565758f5e427252e20716a8378dd9b7d33058dd63bb8dd36bd5'
AND (
token = 'SM0St6I783FTFZLWrkDdplOgT8fN0+ECi+Y4Cmf01t4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)