UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u9AU40/mdnnpnl27hOpyEBdvt1g4fGSpoNvs0wV5LL0='
WHERE
key_id = '1ecfb0212e0268984a09495d39cc5a840b8fd64a00f5cd8da104aab6de651340'
AND (
token = 'u9AU40/mdnnpnl27hOpyEBdvt1g4fGSpoNvs0wV5LL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)