UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'snT5J+KMftLNbHt/Gce3MhmPqa28WR3AdK27NG9mqhM='
WHERE
key_id = '7f98319207c30649e7c11949174e3eb20ca50e3576110d13761588952217517e'
AND (
token = 'snT5J+KMftLNbHt/Gce3MhmPqa28WR3AdK27NG9mqhM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)