UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0NkIi6sZMzTebGwGabqmaaTNtIp3jlg4jf0mR32iSns='
WHERE
key_id = 'e16342abb2c4ffb32d139e422b94a8bce25d21960482dbf1cd6f37033376906d'
AND (
token = '0NkIi6sZMzTebGwGabqmaaTNtIp3jlg4jf0mR32iSns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)