UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NwP4HtENXgbMWu4v0YNIKPLjonNZ/gi4IjxRRi9GrbQ='
WHERE
key_id = '54a332aaca252ad33ae52921574b2b333e6565cd04b2926c477cca8e1a961b99'
AND (
token = 'NwP4HtENXgbMWu4v0YNIKPLjonNZ/gi4IjxRRi9GrbQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)