UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6THvkt998Knqvbd0/31kppztUFwBy0A5LY+NpDkGSiQ='
WHERE
key_id = 'da911e4f81607b5ff995bd49d3acd312ec5ab21d73af8b2024d5ebb81fb1a786'
AND (
token = '6THvkt998Knqvbd0/31kppztUFwBy0A5LY+NpDkGSiQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)