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