UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+rAtqepIjpgcQISIHBRBSMSZ7UgSJgRxENSDXD95eWc='
WHERE
key_id = '4bc5b71aef62e2246c80695c59cdf61c0c3497ea21dacc3cb9b5f074889df307'
AND (
token = '+rAtqepIjpgcQISIHBRBSMSZ7UgSJgRxENSDXD95eWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)