UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sJI75nUp4RDf6tIZugr6NhZ4hVsHzTIccXC8iL1qCKM='
WHERE
key_id = 'e1789e9cafd37cfe0d1d78a8aa50458370a1a0f3d697f918b300e82892375c42'
AND (
token = 'sJI75nUp4RDf6tIZugr6NhZ4hVsHzTIccXC8iL1qCKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)