UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fd4QBDuTLO9Nr1YhX2kHboehrvq4ePwaVEmCukGnV5M='
WHERE
key_id = '12ee180e854e3696b51e2d29a11347d47d69b21031d37027d573acedd73da164'
AND (
token = 'fd4QBDuTLO9Nr1YhX2kHboehrvq4ePwaVEmCukGnV5M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)