UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8gvR4TEk1RzOuhIVEG4tHp76E77vVaUg+Iga1jekp+U='
WHERE
key_id = 'ac5fab60189e9037b5d473c1c044c02191f1bf63e4c2c299c8e8b2a7b132df3e'
AND (
token = '8gvR4TEk1RzOuhIVEG4tHp76E77vVaUg+Iga1jekp+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)