UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4cYiyNx23JDMkT2NIoXHcfEkWAiPwhZsNNgWzfzSssc='
WHERE
key_id = '78ea60e1c47fe02657e9bcce7aee647a954e3d5bbe14e897018c03118f195964'
AND (
token = '4cYiyNx23JDMkT2NIoXHcfEkWAiPwhZsNNgWzfzSssc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)