UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PrAQ/vP5ADaPEylN9y5JJRAHOjHjYAw9VresvPInWrM='
WHERE
key_id = 'f7ef936ac41fdf5dcc3bba4c3c67b3527ac0757e91f1d67c1358731a8237ed54'
AND (
token = 'PrAQ/vP5ADaPEylN9y5JJRAHOjHjYAw9VresvPInWrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)