UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zirDd96cuQhf14qRmDKUvHVGkU057lI1BAgxXB190z8='
WHERE
key_id = '21a53645901be4f14dc1f6dc691dac3df94aa09b4e442a8b2b8f5f10115df744'
AND (
token = 'zirDd96cuQhf14qRmDKUvHVGkU057lI1BAgxXB190z8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)