UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GGi1qt+Ep+kw9HTQ3CqK7Mvqx2ngC60C8miQKqIdDro='
WHERE
key_id = 'c58516443428758a31b8ab1911bf1cce87aee825d30f55b416aa1e9795dac656'
AND (
token = 'GGi1qt+Ep+kw9HTQ3CqK7Mvqx2ngC60C8miQKqIdDro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)