UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DWe30Bm6fHPcoxfQ5PnlOmKZ4mXGAj7tIiVZClxbuoA='
WHERE
key_id = '4855dd9e6752f03d6890fbeabaacc82d817664229049fd3de1b6e8c60450f3c0'
AND (
token = 'DWe30Bm6fHPcoxfQ5PnlOmKZ4mXGAj7tIiVZClxbuoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)