UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0DKl89vvy66RlbBQlYQyAa8dl10LCS20AH/jXZn8nIc='
WHERE
key_id = '9ab1e42958e6055e595762c90f5b1fcfe3c84ed3c932dcace0c2105c20fae33f'
AND (
token = '0DKl89vvy66RlbBQlYQyAa8dl10LCS20AH/jXZn8nIc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)