UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '40TKvBwcmpGYbiWBgomiKM377t2ZMWBh4g6S8PIufC4='
WHERE
key_id = 'cf6d9a33210bd95502f71be1a7a5b1748d12d12ea4308215a3c524840564a734'
AND (
token = '40TKvBwcmpGYbiWBgomiKM377t2ZMWBh4g6S8PIufC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)