UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PXmqnmeem86W2Potm+IVuUjyVal6ffr0K0gsOuPM9uM='
WHERE
key_id = '3b9be91f9f62986d1ba17fdc15f757dfa8e1f3e1606e387b2c4bab314fc29889'
AND (
token = 'PXmqnmeem86W2Potm+IVuUjyVal6ffr0K0gsOuPM9uM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)