UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NF5NmFbk7smEpoBC/PZzz0mWl6snjCWZzw6nzg+NF4w='
WHERE
key_id = 'b733972be03fd918d8f1e6c4332e95544905288d2987121d0c299a7f3b0e3243'
AND (
token = 'NF5NmFbk7smEpoBC/PZzz0mWl6snjCWZzw6nzg+NF4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)