UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2RsFXqS9bb/0ox1A48wzVRPXfsLmwIvuj2It+TqhPA0='
WHERE
key_id = '25675dd2a04416d381620fe489ba88c2158000f7542e980b0563271c9befe0f7'
AND (
token = '2RsFXqS9bb/0ox1A48wzVRPXfsLmwIvuj2It+TqhPA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)