UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '38YZp33Cq2nN5xpkWv5dbnJHLLuHtZ/zKcitLvW9Pb8='
WHERE
key_id = '4dbfea30e67343f90fa37072fd972fa74ddf19e983b01765017ae21dc8b28ee1'
AND (
token = '38YZp33Cq2nN5xpkWv5dbnJHLLuHtZ/zKcitLvW9Pb8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)