UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G5oEiK2BMxRHIlk9CVoYGEHLgnQWI+sG72rrHo9xtPs='
WHERE
key_id = '1f2521b2ef357207189a442487b6acd28418a1d9586723a97c211d54bf52595f'
AND (
token = 'G5oEiK2BMxRHIlk9CVoYGEHLgnQWI+sG72rrHo9xtPs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)