UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HugBFp6UER3ymZA7M28/vt0qZya/wQO5sbPZv2JtCAc='
WHERE
key_id = 'c643a645346bb235f4cd7ffb930757d351fb36b65de579abdaf9c0af85a83a52'
AND (
token = 'HugBFp6UER3ymZA7M28/vt0qZya/wQO5sbPZv2JtCAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)