UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2BNiDqIfpAnIyOM7zjxzOmdYcNaf7be5xB4nKHbnR84='
WHERE
key_id = 'edb90e7246e8375fbd76471a8168d4ec077442fc2049c25490424e41a42d719b'
AND (
token = '2BNiDqIfpAnIyOM7zjxzOmdYcNaf7be5xB4nKHbnR84='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)