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