UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9nkMCyPkotVvn6s0DrcIzBWIf4NinC/cSVg5GPsmvLQ='
WHERE
key_id = '328718f6ae71358b341863fc8dd4932928e5b038b9c0fc025d7ca472b37843df'
AND (
token = '9nkMCyPkotVvn6s0DrcIzBWIf4NinC/cSVg5GPsmvLQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)