UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/zsJLDlGz33D6saiHbf2+MJp00m44F8oIckWsZyFqCg='
WHERE
key_id = 'd83e990ff578c1bab6b150ebe5b0e8b728c1f1735e168ca11d9fd6c2b67aedef'
AND (
token = '/zsJLDlGz33D6saiHbf2+MJp00m44F8oIckWsZyFqCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)