UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FNrWJ0C7GAhT64zMno88yBPYoTro2txPF4VLiD+Pato='
WHERE
key_id = '7b2e8d4c29e216ffe0c8187f32e94261063a02ea3bd42a2787504f5dd1af2ac0'
AND (
token = 'FNrWJ0C7GAhT64zMno88yBPYoTro2txPF4VLiD+Pato='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)