UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GgwXd6AHvjRitwTEbxTGwFFNmIswK8HUIJ0wgsUE6qg='
WHERE
key_id = 'ae79a30c364b943405d5865f10f452147bb93e98443419b1d54b72c726c0300b'
AND (
token = 'GgwXd6AHvjRitwTEbxTGwFFNmIswK8HUIJ0wgsUE6qg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)