UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EDpaBoFtxfieOKjYLeOdWCMz9j6EeLr+dYGn0aEwrQs='
WHERE
key_id = 'a8146e524b7d3314700167de88a16bef50b337f9cc3024d13661be9f205096e6'
AND (
token = 'EDpaBoFtxfieOKjYLeOdWCMz9j6EeLr+dYGn0aEwrQs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)