UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DW7OiPi0i9fTragK0BUJviUM0RMXtUgFW1pSJusnirg='
WHERE
key_id = 'e52cb79eb9235db9515565c9e6eeee5bbecd33a36e3420ac2b2cdafde04d352a'
AND (
token = 'DW7OiPi0i9fTragK0BUJviUM0RMXtUgFW1pSJusnirg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)